thank you so much for this by this a can do many things and gain knowledge
Hi Sumit.. thanks for this complete and useful video on DATE and TIME functions. I especially like the tip for the .INTL functions using the "0101010" format to customize the days you want to be workdays "0" vs. non-workdays "1". Thanks again for sharing this video series for free. Thumbs up!
6
instead of =DAY(TODAY())+13 if we write =DAY(TODAY()+13) we wont have to be cautious of the value of day exceeding 31!!
Hi, when i type 12.00 AM in my excel sheet the input is takes as text and is aligned to the left. But in your video the input is aligned to the left. So what to do. I tried fomat cell using right click and changed it to a number but still it remained right aligned?
date and time function are not properly working in 2007...version
I didn't understand this 41699 logic. Can anybody please explain me
1
Hai Sumit great videos..How to sum up the data within a specified date range.. Eg; many entries pertaining to january2019..need your advise
hello, first i want to thank you for your in dept exel course. is it possible to make a timing format were you dont have to type the colon between hours and minutes? i have to type a lot of timings and was wondering if it is possible to type it in the format of 1412 i.o. 14:12 and exel changes it automaticly. many thanks in advance
how to find workbooks that used in these tutorials
When I use NETWORKDAYS formula to find out working days between the start date and end date i.e., 01/03/2014 and 09/06/2014 then my output is 176 and in video the output is 71 what should I do to correct my output????
Hello everyone, can anyone explain that different serial number can converted into date format at once , where I have 20 lakh serial numbers?
Hi Mr. Sumit! I'm trying to SUMIF using the month as a criterion. In this instance, I'd like to add all sales in January. Why can't I just calculate it using "=MONTH( cell with date )" directly in the SUMIF, then equate it to 1, since 1 denotes January anyway? Here's what I'm trying to fix: =SUMIF( dates in column A , "MONTH(A1)=1", sales in column B ) Could you help me point out a rule that I violated or may have missed, please?
Hello Sumit. Thank you for your teaching Excel in simple way. I have a doubt. I didn't understand =Day(41699) How this number mean 01-March-2014. March is 3rd month in calendar and April is 4th right. Can you please elaborate =Day(41699).
how does 41699 represent 1st march 2014
1
Thanks for the this course.
a great tutorial, thank you so much !
Very helpful, thnx..
Awesome 👌